﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class ePioneer_Center_ep_reservation : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int ciId = 0;
            if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
            {
                ciId = Convert.ToInt32(Request.QueryString["id"]);
            }
            EMPCModel.EMPCEntities dal = new EMPCModel.EMPCEntities();
            var list = from p in dal.ePioneer_Reservation
                       join a in dal.ePioneer_UserInfo
                       on p.UserId equals a.Id
                       where p.CourseInfoId == ciId
                       select new { p.CourseInfoId, p.CreateDate, p.Id, p.IsClose, p.Score, p.UserId, a.Email, a.Mobile, a.UserName };
            RepeaterReservation.DataSource = list;
            RepeaterReservation.DataBind();
        }
    }
}